CSV File Structures (Nominal Ledger Records)

 

Field

Type

Size

 Validation

Precision

Import Type

Nominal Code

Char

8

Yes

 

Standard / Extended

Name

Char

60

 

 

Standard / Extended

Yearly Budget (Total of Budgets Months 1-12)

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 1

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 2

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 3

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 4

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 5

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 6

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 7

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 8

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 9

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 10

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 11

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 12

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Actuals - Bfwd, Months 1-12, Future

---

---

 

 

Not Included

Prior Year Month 1

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 2

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 3

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 4

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 5

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 6

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 7

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 8

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 9

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 10

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 11

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 12

Double

11

 

8 digits + 2 d.p.

Extended

Include in Quick Ratio?

---

---

 

 

Not Included

Memo

---

---

 

 

Not Included

Related Topics

To Import Data

Preparing Data to be Imported

Import File Details